import pandas as pd
list = [[110,120,105],[95,119,108],[98,80,100],[112,106,97]]
index = ['王蒙','李珊','赵胜','刘文']
columns = ['语文','数学','英语']
dict = {"高三（1）班"}
df = pd.DataFrame(list,index,columns)
print('原始数据:\n',df)
print('选取所有学生的语文成绩:\n',df['语文'])
print('选取所有学生的语文和数学成绩:\n',df[['语文','数学']])
print('选取王蒙到赵胜的语文和英语成绩:\n',df[['语文','英语']]['王蒙':'赵胜'])
print('选取李珊及后面学生的所有成绩:\n',df[['语文','数学','英语']]['李珊':])
print(df.values)
print(df.dtypes)
print(df.index)
print(df.columns)
print(df.T)
print(df.head())
print(df.tail())
print(df.shape)
print(df.info)